IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetRoles]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GetRoles]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
  
CREATE  PROCEDURE [dbo].[GetRoles]    
   
AS    
BEGIN    
 SET NOCOUNT ON 
   
SELECT  RoleID, [Name] as 'Role'
FROM admRoleTypes
   
    
 SET NOCOUNT OFF    
END    
GO
